When doing multiple additions and deletions on an indexed data set that also uses COMPRESS=YES and REUSE=YES, some qualifying observations can be missed and left in the data set after some number of iterations.

The following sample code is what we were using to stress the system. It ran correctly 23 times in a macro before a problem was surfaced:

   proc sql;
     delete from tmplib.temp where cdate="&TDate"d;
     insert into tmplib.temp
     select * from temp where cdate="&TDate"d;
   quit;

The failure tends to happen after many iterations. The lowest number of iterations before failure that we have seen in testing is 23.

Open the Hot Fix tab for links to the Hot Fix.

Operating System and Release Information

A fix for SAS 9.1.3 (9.1 TS1M3) for this issue is available at:

A fix for SAS 9.1.3 (9.1 TS1M3) with Asian Language Support (DBCS) for this issue is available at:

A fix for this issue for Base SAS 9.21 is available. However, if you install SAS Maintenance after applying this hot fix, files delivered in the hot fix will not receive the proper Maintenance update. Please contact SAS Technical Support at the link shown below for information on accessing the hot fix.